Query: Select records with missing SecurityGLAccountId
Use these queries to display invalid records (SQL Query): Select distinct [ArtDepPayment].[DBId] from [ArtDepPayment] where ([SecurityGLAccountId] = 0 or [SecurityGLAccountId] is null) and not [ArticleId] = 0 and not [ArticleId] is null Union Select distinct [AccInterest].[DBId] from [AccInterest] where ([SecurityGLAccountId] = 0 or [SecurityGLAccountId] is null) and not [ArticleId] = 0 and not [ArticleId] is … Continue reading Query: Select records with missing SecurityGLAccountId
Copy and paste this URL into your WordPress site to embed
Copy and paste this code into your site to embed